IF OBJECT_ID('ssf.dpnd_get_header_object_name') IS NOT NULL
	DROP FUNCTION ssf.dpnd_get_header_object_name
GO

CREATE FUNCTION ssf.dpnd_get_header_object_name (
	@header_object_id INT
)
RETURNS NVARCHAR(256)
AS
BEGIN
	RETURN (
		SELECT dpnd_object_name
		FROM ssf.dpnd_header_object WITH (NOLOCK)
		WHERE header_object_id = @header_object_id
	)
END
GO
